package com.hos.db.create.consult;

/**
 * 咨询 聊天
 * Created by guom on 2018/10/15.
 */
public class ConsultChatTable {
    public static String tableName = "consult_chat";
    public static String tableConsultId = "consult_id";//咨询id
    public static String tableChatId = "chat_id";//消息id
    public static String tableChatSendType = "chat_send_type";//发送者类型 doc,pat
    public static String tableChatSendTime = "chat_send_time";//发送时间
    public static String tableChatMsg = "chat_msg";//消息
    public static String tableChatType = "chat_type";//消息类型    //TEXT文字 PIC 图片
    public static String tableChatImageW = "chat_image_w";//消息图片宽
    public static String tableChatImageH = "chat_image_h";//消息图片高


    public static String careteTable = "create table  "
            + tableName + " ( "
            + tableChatId + "  varchar(200) primary key, "//主键
            + tableConsultId + " varchar(200), "
            + tableChatMsg + " longText,"
            + tableChatSendType + " varchar(100), "
            + tableChatType + " varchar(100), "
            + tableChatImageW + " int, "
            + tableChatImageH + " int, "
            + tableChatSendTime + " datetime "
            + "); ";

}
